Oracle APEX

Very fast database level applications
Applications where reports and forms are there
Getting data from various sources like cloud

The most suitable case for Oracle Application Express is any application, web desktop or mobile, that only needs to store and manipulate data in Oracle Database, and be accessed online all the time.

Other than that, avoid Oracle Application Express (e.g., apps which rely heavily to Javascript functionality, apps to analyze Twitter data, apps which need to manipulate OS files, apps to create complex and static reports).

Best for web applications. Less appropriate, however, for mobile applications. Applications that deal with businesses are quite useful.

It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.

Oracle Application Express can essentially be used for any web application that needs to talk to an Oracle Database. Simple applications to view/edit data can be turned out in next to no time with the built-in reports allowing fine-grained control for the end user. It really shines when used for tasks such as dashboard management or basic manipulation of data, all of which can be done with next to no code.

For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.

The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.

Almost any business requirement with data-centric aspects can be covered - no limitations.
ERP, CRM, HCM, Financials, mobile apps.

It's well suited if you need to display (or enter/change) data from an Oracle database. If you (or your customer) think you definitely need a native app, then it is not a good fit. Creating a dashboard with different kinds of charts and KPI's is easy using APEX. If you need a real data-mining solution, then you better switch to Oracle Analytics. As APEX offers an easy interface for RESTful services, you can also create forms, reports, and charts upon any RESTful service that's available on the internet -- either within or outside your organization.

We have converted a lot of old SharePoint processes to Apex applications. We are developing new applications using this tool. Most of the applications are being utilized to transition old processes to make them more efficient. The worst part of the software is having to strictly follow the structure, we cannot put as many columns and items as we would like and we would enjoy that customization.

Oracle APEX is a Versatile tool. Though it is database specific, it can be used with many other different technologies. Also, it is accessible from browser as well as mobile.

It is a nice and inexpensive tool, ideal to extend the functionality of the systems, and offer users good reports, graphics and easy-to-use applications, developed with speed and low maintenance cost. We don’t use it when we have to customize standard processes in our ERP, mainly because we are SOX compliant, and it is more difficult to us to prove our auditors that we respect and accomplish with all the validations and controls they demand.

This is well suited for order entry, displaying information on mobile devices, getting prototype applications up quickly, and more. Reports are rather robust too and again easy to assemble and put up. APEX is wizard-based or you can open the app and make your changes via the web environment as well. It is best for working over the web, collecting information and displaying information.

If there is a time limit and more security is required one should go with it as it provides locking functionality to prevent a deadlock situation.

Automation scenario : Suppose there is a user group that maintains Excel or their daily cost data entry. There are 4 users who work on the cost Excel worksheet. It can be individual or a shared excel. Once the data entry is done the data need to be reported in a BI report and distributed. Excel data entry can have fat fingering or typo errors that can cause issues with a report. In this situation we can use APEX and design a form that the 4 users can access at the same time, we can track which user is making what changes and without any delay once the data is committed in the form it can be made available for BI reporting . For small to medium size organization APEX can be used as a low cost BI tool for reporting and forms need, as it is free with the Oracle license.

ApEx is a fantastic tool to create web pages (the easiest access point for anything) for users. It can be mainly used to create reports or insert forms on small database tables or for invoking web-services from other tools or integrating other web tools. For example, it may be used as a monitor for Oracle Data Integrator flows, directly selecting logs from the ODI work repository or from custom tables. Moreover, through the invocations of ODI agent web-service, ApEx also allows us to execute ODI flows (keep an eye on agent license for this purpose). Finally, and the simplest scenario, it can be used to directly write inside a table or loading a file in it. On the contrary, ApEx is not suited at all as a reporting tool, since its pagination and graphical rearrangement are quite limited.